Online Shoppers EDA

Dataset statistics

Number of variables	18
Number of observations	12330
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	125
Duplicate rows (%)	1.0%
Total size in memory	2.9 MiB
Average record size in memory	247.1 B

Variable types

Numeric	14
Categorical	2
Boolean	2

Warnings

Dataset has 125 (1.0%) duplicate rows	Duplicates
`BounceRates` is highly correlated with `ExitRates`	High correlation
`ExitRates` is highly correlated with `BounceRates`	High correlation
`Administrative` has 5768 (46.8%) zeros	Zeros
`Administrative_Duration` has 5903 (47.9%) zeros	Zeros
`Informational` has 9699 (78.7%) zeros	Zeros
`Informational_Duration` has 9925 (80.5%) zeros	Zeros
`ProductRelated_Duration` has 755 (6.1%) zeros	Zeros
`BounceRates` has 5518 (44.8%) zeros	Zeros
`PageValues` has 9600 (77.9%) zeros	Zeros
`SpecialDay` has 11079 (89.9%) zeros	Zeros

Reproduction

Analysis started	2021-02-12 05:17:50.253775
Analysis finished	2021-02-12 05:18:50.098224
Duration	59.84 seconds
Software version	pandas-profiling v2.10.1
Download configuration	config.yaml

Administrative
Real number (ℝ_≥0)

ZEROS

Distinct	27
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.315166261
Minimum	0
Maximum	27
Zeros	5768
Zeros (%)	46.8%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	9
Maximum	27
Range	27
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.321784106
Coefficient of variation (CV)	1.434792897
Kurtosis	4.701146249
Mean	2.315166261
Median Absolute Deviation (MAD)	1
Skewness	1.960357209
Sum	28546
Variance	11.03424965
Monotocity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
0	5768	46.8%
1	1354	11.0%
2	1114	9.0%
3	915	7.4%
4	765	6.2%
5	575	4.7%
6	432	3.5%
7	338	2.7%
8	287	2.3%
9	225	1.8%
Other values (17)	557	4.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5768	46.8%
1	1354	11.0%
2	1114	9.0%
3	915	7.4%
4	765	6.2%
5	575	4.7%
6	432	3.5%
7	338	2.7%
8	287	2.3%
9	225	1.8%

Value	Count	Frequency (%)
27	1	< 0.1%
26	1	< 0.1%
24	4	< 0.1%
23	3	< 0.1%
22	4	< 0.1%
21	2	< 0.1%
20	2	< 0.1%
19	6	< 0.1%
18	12	0.1%
17	16	0.1%

Administrative_Duration
Real number (ℝ_≥0)

ZEROS

Distinct	3335
Distinct (%)	27.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	80.81861054
Minimum	0
Maximum	3398.75
Zeros	5903
Zeros (%)	47.9%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	7.5
Q3	93.25625
95-th percentile	348.2663691
Maximum	3398.75
Range	3398.75
Interquartile range (IQR)	93.25625

Descriptive statistics

Standard deviation	176.7791075
Coefficient of variation (CV)	2.187356431
Kurtosis	50.55673905
Mean	80.81861054
Median Absolute Deviation (MAD)	7.5
Skewness	5.615719019
Sum	996493.468
Variance	31250.85284
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5903	47.9%
4	56	0.5%
5	53	0.4%
7	45	0.4%
11	42	0.3%
6	41	0.3%
14	37	0.3%
9	35	0.3%
15	33	0.3%
10	32	0.3%
Other values (3325)	6053	49.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5903	47.9%
1.333333333	1	< 0.1%
2	15	0.1%
3	26	0.2%
3.5	4	< 0.1%
4	56	0.5%
4.333333333	1	< 0.1%
4.5	2	< 0.1%
4.75	1	< 0.1%
5	53	0.4%

Value	Count	Frequency (%)
3398.75	1	< 0.1%
2720.5	1	< 0.1%
2657.318056	1	< 0.1%
2629.253968	1	< 0.1%
2407.42381	1	< 0.1%
2156.166667	1	< 0.1%
2137.112745	1	< 0.1%
2086.75	1	< 0.1%
2047.234848	1	< 0.1%
1951.279141	1	< 0.1%

Informational
Real number (ℝ_≥0)

ZEROS

Distinct	17
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.503568532
Minimum	0
Maximum	24
Zeros	9699
Zeros (%)	78.7%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	24
Range	24
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.270156426
Coefficient of variation (CV)	2.522310957
Kurtosis	26.93226626
Mean	0.503568532
Median Absolute Deviation (MAD)	0
Skewness	4.03646376
Sum	6209
Variance	1.613297346
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	9699	78.7%
1	1041	8.4%
2	728	5.9%
3	380	3.1%
4	222	1.8%
5	99	0.8%
6	78	0.6%
7	36	0.3%
9	15	0.1%
8	14	0.1%
Other values (7)	18	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9699	78.7%
1	1041	8.4%
2	728	5.9%
3	380	3.1%
4	222	1.8%
5	99	0.8%
6	78	0.6%
7	36	0.3%
8	14	0.1%
9	15	0.1%

Value	Count	Frequency (%)
24	1	< 0.1%
16	1	< 0.1%
14	2	< 0.1%
13	1	< 0.1%
12	5	< 0.1%
11	1	< 0.1%
10	7	0.1%
9	15	0.1%
8	14	0.1%
7	36	0.3%

Informational_Duration
Real number (ℝ_≥0)

ZEROS

Distinct	1258
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	34.47239793
Minimum	0
Maximum	2549.375
Zeros	9925
Zeros (%)	80.5%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	195
Maximum	2549.375
Range	2549.375
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	140.7492944
Coefficient of variation (CV)	4.082956304
Kurtosis	76.31685309
Mean	34.47239793
Median Absolute Deviation (MAD)	0
Skewness	7.579184716
Sum	425044.6664
Variance	19810.36388
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9925	80.5%
9	33	0.3%
6	26	0.2%
10	26	0.2%
7	26	0.2%
12	23	0.2%
13	23	0.2%
8	22	0.2%
16	22	0.2%
11	21	0.2%
Other values (1248)	2183	17.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9925	80.5%
1	3	< 0.1%
1.5	1	< 0.1%
2	11	0.1%
2.5	1	< 0.1%
3	16	0.1%
3.5	1	< 0.1%
4	17	0.1%
5	18	0.1%
5.5	3	< 0.1%

Value	Count	Frequency (%)
2549.375	1	< 0.1%
2256.916667	1	< 0.1%
2252.033333	1	< 0.1%
2195.3	1	< 0.1%
2166.5	1	< 0.1%
2050.433333	1	< 0.1%
1949.166667	1	< 0.1%
1830.5	1	< 0.1%
1779.166667	1	< 0.1%
1778	1	< 0.1%

ProductRelated
Real number (ℝ_≥0)

Distinct	311
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	31.73146796
Minimum	0
Maximum	705
Zeros	38
Zeros (%)	0.3%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	7
median	18
Q3	38
95-th percentile	109
Maximum	705
Range	705
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	44.4755033
Coefficient of variation (CV)	1.401621361
Kurtosis	31.21170665
Mean	31.73146796
Median Absolute Deviation (MAD)	13
Skewness	4.341516416
Sum	391249
Variance	1978.070394
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	622	5.0%
2	465	3.8%
3	458	3.7%
4	404	3.3%
6	396	3.2%
7	391	3.2%
5	382	3.1%
8	370	3.0%
10	330	2.7%
9	317	2.6%
Other values (301)	8195	66.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	38	0.3%
1	622	5.0%
2	465	3.8%
3	458	3.7%
4	404	3.3%
5	382	3.1%
6	396	3.2%
7	391	3.2%
8	370	3.0%
9	317	2.6%

Value	Count	Frequency (%)
705	1	< 0.1%
686	1	< 0.1%
584	1	< 0.1%
534	1	< 0.1%
518	1	< 0.1%
517	1	< 0.1%
501	1	< 0.1%
486	1	< 0.1%
470	1	< 0.1%
449	1	< 0.1%

ProductRelated_Duration
Real number (ℝ_≥0)

ZEROS

Distinct	9551
Distinct (%)	77.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1194.74622
Minimum	0
Maximum	63973.52223
Zeros	755
Zeros (%)	6.1%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	184.1375
median	598.9369047
Q3	1464.157214
95-th percentile	4300.289077
Maximum	63973.52223
Range	63973.52223
Interquartile range (IQR)	1280.019714

Descriptive statistics

Standard deviation	1913.669288
Coefficient of variation (CV)	1.601737052
Kurtosis	137.1741637
Mean	1194.74622
Median Absolute Deviation (MAD)	500.9369047
Skewness	7.263227683
Sum	14731220.89
Variance	3662130.143
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	755	6.1%
17	21	0.2%
8	17	0.1%
11	17	0.1%
15	16	0.1%
19	15	0.1%
22	15	0.1%
12	15	0.1%
7	14	0.1%
13	14	0.1%
Other values (9541)	11431	92.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	755	6.1%
0.5	1	< 0.1%
1	2	< 0.1%
2.333333333	1	< 0.1%
2.666666667	1	< 0.1%
3	5	< 0.1%
4	10	0.1%
5	13	0.1%
5.333333333	1	< 0.1%
6	5	< 0.1%

Value	Count	Frequency (%)
63973.52223	1	< 0.1%
43171.23338	1	< 0.1%
29970.46597	1	< 0.1%
27009.85943	1	< 0.1%
24844.1562	1	< 0.1%
23888.81	1	< 0.1%
23342.08205	1	< 0.1%
23050.10414	1	< 0.1%
21857.04648	1	< 0.1%
21672.24425	1	< 0.1%

BounceRates
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1872
Distinct (%)	15.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.02219138047
Minimum	0
Maximum	0.2
Zeros	5518
Zeros (%)	44.8%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.0031124675
Q3	0.0168125585
95-th percentile	0.2
Maximum	0.2
Range	0.2
Interquartile range (IQR)	0.0168125585

Descriptive statistics

Standard deviation	0.04848832181
Coefficient of variation (CV)	2.185007006
Kurtosis	7.723159431
Mean	0.02219138047
Median Absolute Deviation (MAD)	0.0031124675
Skewness	2.947855267
Sum	273.6197212
Variance	0.002351117352
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5518	44.8%
0.2	700	5.7%
0.066666667	134	1.1%
0.028571429	115	0.9%
0.05	113	0.9%
0.033333333	101	0.8%
0.025	100	0.8%
0.016666667	99	0.8%
0.1	98	0.8%
0.04	96	0.8%
Other values (1862)	5256	42.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5518	44.8%
2.73 × 10⁵	1	< 0.1%
3.35 × 10⁵	1	< 0.1%
3.83 × 10⁵	1	< 0.1%
3.94 × 10⁵	1	< 0.1%
7.09 × 10⁵	1	< 0.1%
7.27 × 10⁵	1	< 0.1%
7.5 × 10⁵	1	< 0.1%
8.01 × 10⁵	1	< 0.1%
8.08 × 10⁵	1	< 0.1%

Value	Count	Frequency (%)
0.2	700	5.7%
0.183333333	1	< 0.1%
0.18	5	< 0.1%
0.176923077	1	< 0.1%
0.175	1	< 0.1%
0.166666667	4	< 0.1%
0.164285714	1	< 0.1%
0.164230769	1	< 0.1%
0.161904762	1	< 0.1%
0.16	3	< 0.1%

ExitRates
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	4777
Distinct (%)	38.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.04307279777
Minimum	0
Maximum	0.2
Zeros	76
Zeros (%)	0.6%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.004567568
Q1	0.014285714
median	0.0251564025
Q3	0.05
95-th percentile	0.2
Maximum	0.2
Range	0.2
Interquartile range (IQR)	0.035714286

Descriptive statistics

Standard deviation	0.04859654055
Coefficient of variation (CV)	1.128242024
Kurtosis	4.017034553
Mean	0.04307279777
Median Absolute Deviation (MAD)	0.0141725795
Skewness	2.148789
Sum	531.0875965
Variance	0.002361623754
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.2	710	5.8%
0.1	338	2.7%
0.05	329	2.7%
0.033333333	291	2.4%
0.066666667	267	2.2%
0.025	224	1.8%
0.04	214	1.7%
0.016666667	181	1.5%
0.02	167	1.4%
0.022222222	152	1.2%
Other values (4767)	9457	76.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	76	0.6%
0.000175593	1	< 0.1%
0.000250438	1	< 0.1%
0.000262123	1	< 0.1%
0.000263158	1	< 0.1%
0.000292398	1	< 0.1%
0.000409836	1	< 0.1%
0.000446429	1	< 0.1%
0.000468384	1	< 0.1%
0.000480769	1	< 0.1%

Value	Count	Frequency (%)
0.2	710	5.8%
0.192307692	1	< 0.1%
0.188888889	2	< 0.1%
0.186666667	4	< 0.1%
0.183333333	2	< 0.1%
0.181818182	1	< 0.1%
0.18034188	1	< 0.1%
0.18	3	< 0.1%
0.177777778	5	< 0.1%
0.175	6	< 0.1%

PageValues
Real number (ℝ_≥0)

ZEROS

Distinct	2704
Distinct (%)	21.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.889257863
Minimum	0
Maximum	361.7637419
Zeros	9600
Zeros (%)	77.9%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	38.16052828
Maximum	361.7637419
Range	361.7637419
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	18.56843661
Coefficient of variation (CV)	3.152933195
Kurtosis	65.63569361
Mean	5.889257863
Median Absolute Deviation (MAD)	0
Skewness	6.382964249
Sum	72614.54945
Variance	344.7868381
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9600	77.9%
53.988	6	< 0.1%
42.29306752	3	< 0.1%
16.1585582	2	< 0.1%
12.55885714	2	< 0.1%
59.988	2	< 0.1%
10.99901844	2	< 0.1%
40.4014481	2	< 0.1%
34.03997536	2	< 0.1%
21.2112655	2	< 0.1%
Other values (2694)	2707	22.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9600	77.9%
0.038034542	1	< 0.1%
0.067049546	1	< 0.1%
0.093546949	1	< 0.1%
0.098621403	1	< 0.1%
0.120699914	1	< 0.1%
0.129676893	1	< 0.1%
0.131837013	1	< 0.1%
0.139200623	1	< 0.1%
0.150650498	1	< 0.1%

Value	Count	Frequency (%)
361.7637419	1	< 0.1%
360.9533839	1	< 0.1%
287.9537928	1	< 0.1%
270.7846931	1	< 0.1%
261.4912857	1	< 0.1%
258.5498732	1	< 0.1%
255.5691579	1	< 0.1%
254.6071579	1	< 0.1%
246.7585902	1	< 0.1%
239.98	1	< 0.1%

SpecialDay
Real number (ℝ_≥0)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.06142741281
Minimum	0
Maximum	1
Zeros	11079
Zeros (%)	89.9%
Memory size	96.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.6
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1989172732
Coefficient of variation (CV)	3.238249245
Kurtosis	9.91365887
Mean	0.06142741281
Median Absolute Deviation (MAD)	0
Skewness	3.302666747
Sum	757.4
Variance	0.03956808156
Monotocity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	11079	89.9%
0.6	351	2.8%
0.8	325	2.6%
0.4	243	2.0%
0.2	178	1.4%
1	154	1.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	11079	89.9%
0.2	178	1.4%
0.4	243	2.0%
0.6	351	2.8%
0.8	325	2.6%
1	154	1.2%

Value	Count	Frequency (%)
1	154	1.2%
0.8	325	2.6%
0.6	351	2.8%
0.4	243	2.0%
0.2	178	1.4%
0	11079	89.9%

Month
Categorical

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	722.9 KiB

May	3364
Nov	2998
Mar	1907
Dec	1727
Oct	549
Other values (5)	1785

Length

Max length	4
Median length	3
Mean length	3.023357664
Min length	3

Characters and Unicode

Total characters	37278
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Feb
2nd row	Feb
3rd row	Feb
4th row	Feb
5th row	Feb

Value	Count	Frequency (%)
May	3364	27.3%
Nov	2998	24.3%
Mar	1907	15.5%
Dec	1727	14.0%
Oct	549	4.5%
Sep	448	3.6%
Aug	433	3.5%
Jul	432	3.5%
June	288	2.3%
Feb	184	1.5%

Histogram of lengths of the category

Value	Count	Frequency (%)
may	3364	27.3%
nov	2998	24.3%
mar	1907	15.5%
dec	1727	14.0%
oct	549	4.5%
sep	448	3.6%
aug	433	3.5%
jul	432	3.5%
june	288	2.3%
feb	184	1.5%

Most occurring characters

Value	Count	Frequency (%)
M	5271	14.1%
a	5271	14.1%
y	3364	9.0%
N	2998	8.0%
o	2998	8.0%
v	2998	8.0%
e	2647	7.1%
c	2276	6.1%
r	1907	5.1%
D	1727	4.6%
Other values (12)	5821	15.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	24948	66.9%
Uppercase Letter	12330	33.1%

Most frequent character per category

Value	Count	Frequency (%)
a	5271	21.1%
y	3364	13.5%
o	2998	12.0%
v	2998	12.0%
e	2647	10.6%
c	2276	9.1%
r	1907	7.6%
u	1153	4.6%
t	549	2.2%
p	448	1.8%
Other values (4)	1337	5.4%

Value	Count	Frequency (%)
M	5271	42.7%
N	2998	24.3%
D	1727	14.0%
J	720	5.8%
O	549	4.5%
S	448	3.6%
A	433	3.5%
F	184	1.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37278	100.0%

Most frequent character per script

Value	Count	Frequency (%)
M	5271	14.1%
a	5271	14.1%
y	3364	9.0%
N	2998	8.0%
o	2998	8.0%
v	2998	8.0%
e	2647	7.1%
c	2276	6.1%
r	1907	5.1%
D	1727	4.6%
Other values (12)	5821	15.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37278	100.0%

Most frequent character per block

Value	Count	Frequency (%)
M	5271	14.1%
a	5271	14.1%
y	3364	9.0%
N	2998	8.0%
o	2998	8.0%
v	2998	8.0%
e	2647	7.1%
c	2276	6.1%
r	1907	5.1%
D	1727	4.6%
Other values (12)	5821	15.6%

OperatingSystems
Real number (ℝ_≥0)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.124006488
Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	3
Maximum	8
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.9113248287
Coefficient of variation (CV)	0.4290593432
Kurtosis	10.45684261
Mean	2.124006488
Median Absolute Deviation (MAD)	0
Skewness	2.066285042
Sum	26189
Variance	0.8305129434
Monotocity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	6601	53.5%
1	2585	21.0%
3	2555	20.7%
4	478	3.9%
8	79	0.6%
6	19	0.2%
7	7	0.1%
5	6	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2585	21.0%
2	6601	53.5%
3	2555	20.7%
4	478	3.9%
5	6	< 0.1%
6	19	0.2%
7	7	0.1%
8	79	0.6%

Value	Count	Frequency (%)
8	79	0.6%
7	7	0.1%
6	19	0.2%
5	6	< 0.1%
4	478	3.9%
3	2555	20.7%
2	6601	53.5%
1	2585	21.0%

Browser
Real number (ℝ_≥0)

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.357096513
Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	5
Maximum	13
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.717276676
Coefficient of variation (CV)	0.7285559443
Kurtosis	12.74673269
Mean	2.357096513
Median Absolute Deviation (MAD)	0
Skewness	3.242349611
Sum	29063
Variance	2.94903918
Monotocity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2	7961	64.6%
1	2462	20.0%
4	736	6.0%
5	467	3.8%
6	174	1.4%
10	163	1.3%
8	135	1.1%
3	105	0.9%
13	61	0.5%
7	49	0.4%
Other values (3)	17	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2462	20.0%
2	7961	64.6%
3	105	0.9%
4	736	6.0%
5	467	3.8%
6	174	1.4%
7	49	0.4%
8	135	1.1%
9	1	< 0.1%
10	163	1.3%

Value	Count	Frequency (%)
13	61	0.5%
12	10	0.1%
11	6	< 0.1%
10	163	1.3%
9	1	< 0.1%
8	135	1.1%
7	49	0.4%
6	174	1.4%
5	467	3.8%
4	736	6.0%

Region
Real number (ℝ_≥0)

Distinct	9
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.147364152
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	4
95-th percentile	8
Maximum	9
Range	8
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.401591237
Coefficient of variation (CV)	0.7630484178
Kurtosis	-0.1486803001
Mean	3.147364152
Median Absolute Deviation (MAD)	2
Skewness	0.9835491595
Sum	38807
Variance	5.767640468
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	4780	38.8%
3	2403	19.5%
4	1182	9.6%
2	1136	9.2%
6	805	6.5%
7	761	6.2%
9	511	4.1%
8	434	3.5%
5	318	2.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4780	38.8%
2	1136	9.2%
3	2403	19.5%
4	1182	9.6%
5	318	2.6%
6	805	6.5%
7	761	6.2%
8	434	3.5%
9	511	4.1%

Value	Count	Frequency (%)
9	511	4.1%
8	434	3.5%
7	761	6.2%
6	805	6.5%
5	318	2.6%
4	1182	9.6%
3	2403	19.5%
2	1136	9.2%
1	4780	38.8%

TrafficType
Real number (ℝ_≥0)

Distinct	20
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.069586375
Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	96.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	4
95-th percentile	13
Maximum	20
Range	19
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	4.02516916
Coefficient of variation (CV)	0.9890855703
Kurtosis	3.479710597
Mean	4.069586375
Median Absolute Deviation (MAD)	1
Skewness	1.962986732
Sum	50178
Variance	16.20198677
Monotocity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
2	3913	31.7%
1	2451	19.9%
3	2052	16.6%
4	1069	8.7%
13	738	6.0%
10	450	3.6%
6	444	3.6%
8	343	2.8%
5	260	2.1%
11	247	2.0%
Other values (10)	363	2.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2451	19.9%
2	3913	31.7%
3	2052	16.6%
4	1069	8.7%
5	260	2.1%
6	444	3.6%
7	40	0.3%
8	343	2.8%
9	42	0.3%
10	450	3.6%

Value	Count	Frequency (%)
20	198	1.6%
19	17	0.1%
18	10	0.1%
17	1	< 0.1%
16	3	< 0.1%
15	38	0.3%
14	13	0.1%
13	738	6.0%
12	1	< 0.1%
11	247	2.0%

VisitorType
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	880.2 KiB

Returning_Visitor	10551
New_Visitor	1694
Other	85

Length

Max length	17
Median length	17
Mean length	16.09294404
Min length	5

Characters and Unicode

Total characters	198426
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Returning_Visitor
2nd row	Returning_Visitor
3rd row	Returning_Visitor
4th row	Returning_Visitor
5th row	Returning_Visitor

Value	Count	Frequency (%)
Returning_Visitor	10551	85.6%
New_Visitor	1694	13.7%
Other	85	0.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
returning_visitor	10551	85.6%
new_visitor	1694	13.7%
other	85	0.7%

Most occurring characters

Value	Count	Frequency (%)
i	35041	17.7%
t	22881	11.5%
r	22881	11.5%
n	21102	10.6%
e	12330	6.2%
_	12245	6.2%
V	12245	6.2%
s	12245	6.2%
o	12245	6.2%
R	10551	5.3%
Other values (6)	24660	12.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	161606	81.4%
Uppercase Letter	24575	12.4%
Connector Punctuation	12245	6.2%

Most frequent character per category

Value	Count	Frequency (%)
i	35041	21.7%
t	22881	14.2%
r	22881	14.2%
n	21102	13.1%
e	12330	7.6%
s	12245	7.6%
o	12245	7.6%
u	10551	6.5%
g	10551	6.5%
w	1694	1.0%

Value	Count	Frequency (%)
V	12245	49.8%
R	10551	42.9%
N	1694	6.9%
O	85	0.3%

Value	Count	Frequency (%)
_	12245	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	186181	93.8%
Common	12245	6.2%

Most frequent character per script

Value	Count	Frequency (%)
i	35041	18.8%
t	22881	12.3%
r	22881	12.3%
n	21102	11.3%
e	12330	6.6%
V	12245	6.6%
s	12245	6.6%
o	12245	6.6%
R	10551	5.7%
u	10551	5.7%
Other values (5)	14109	7.6%

Value	Count	Frequency (%)
_	12245	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	198426	100.0%

Most frequent character per block

Value	Count	Frequency (%)
i	35041	17.7%
t	22881	11.5%
r	22881	11.5%
n	21102	10.6%
e	12330	6.2%
_	12245	6.2%
V	12245	6.2%
s	12245	6.2%
o	12245	6.2%
R	10551	5.3%
Other values (6)	24660	12.4%

Weekend
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.2 KiB

False	9462
True	2868

Common Values
Chart

Value	Count	Frequency (%)
False	9462	76.7%
True	2868	23.3%

Revenue
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.2 KiB

False	10422
True	1908

Common Values
Chart

Value	Count	Frequency (%)
False	10422	84.5%
True	1908	15.5%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Administrative	ProductRelated	ProductRelated_Duration	BounceRates	ExitRates	SpecialDay	Month	OperatingSystems	Browser	Region	TrafficType	VisitorType	Weekend	Revenue
0	0	1	0.000000	0.200000	0.200000	0.0	Feb	1	1	1	1	Returning_Visitor	False	False
1	0	2	64.000000	0.000000	0.100000	0.0	Feb	2	2	1	2	Returning_Visitor	False	False
2	0	1	0.000000	0.200000	0.200000	0.0	Feb	4	1	9	3	Returning_Visitor	False	False
3	0	2	2.666667	0.050000	0.140000	0.0	Feb	3	2	2	4	Returning_Visitor	False	False
4	0	10	627.500000	0.020000	0.050000	0.0	Feb	3	3	1	4	Returning_Visitor	True	False
5	0	19	154.216667	0.015789	0.024561	0.0	Feb	2	2	1	3	Returning_Visitor	False	False
6	0	1	0.000000	0.200000	0.200000	0.4	Feb	2	4	3	3	Returning_Visitor	False	False
7	1	0	0.000000	0.200000	0.200000	0.0	Feb	1	2	1	5	Returning_Visitor	True	False
8	0	2	37.000000	0.000000	0.100000	0.8	Feb	2	2	2	3	Returning_Visitor	False	False
9	0	3	738.000000	0.000000	0.022222	0.4	Feb	2	4	1	2	Returning_Visitor	False	False

Last rows

	Administrative	Administrative_Duration	Informational	ProductRelated	ProductRelated_Duration	BounceRates	ExitRates	PageValues	Month	OperatingSystems	Browser	Region	TrafficType	VisitorType	Weekend	Revenue
12320	0	0.00	0	8	143.583333	0.014286	0.050000	0.000000	Nov	2	2	3	1	Returning_Visitor	False	False
12321	0	0.00	0	6	0.000000	0.200000	0.200000	0.000000	Nov	1	8	4	1	Returning_Visitor	False	False
12322	6	76.25	0	22	1075.250000	0.000000	0.004167	0.000000	Dec	2	2	4	2	Returning_Visitor	False	False
12323	2	64.75	0	44	1157.976190	0.000000	0.013953	0.000000	Nov	2	2	1	10	Returning_Visitor	False	False
12324	0	0.00	1	16	503.000000	0.000000	0.037647	0.000000	Nov	2	2	1	1	Returning_Visitor	False	False
12325	3	145.00	0	53	1783.791667	0.007143	0.029031	12.241717	Dec	4	6	1	1	Returning_Visitor	True	False
12326	0	0.00	0	5	465.750000	0.000000	0.021333	0.000000	Nov	3	2	1	8	Returning_Visitor	True	False
12327	0	0.00	0	6	184.250000	0.083333	0.086667	0.000000	Nov	3	2	1	13	Returning_Visitor	True	False
12328	4	75.00	0	15	346.000000	0.000000	0.021053	0.000000	Nov	2	2	3	11	Returning_Visitor	False	False
12329	0	0.00	0	3	21.250000	0.000000	0.066667	0.000000	Nov	3	2	1	2	New_Visitor	True	False

Most frequent

	ProductRelated	BounceRates	ExitRates	Month	OperatingSystems	Browser	Region	TrafficType	VisitorType	Weekend	Revenue	count
26	1	0.2	0.2	Mar	2	2	1	1	Returning_Visitor	False	False	14
36	1	0.2	0.2	Mar	3	2	3	1	Returning_Visitor	False	False	7
44	1	0.2	0.2	May	2	2	1	3	Returning_Visitor	False	False	7
38	1	0.2	0.2	May	1	1	1	3	Returning_Visitor	False	False	6
13	1	0.2	0.2	Dec	8	13	9	20	Other	False	False	5
34	1	0.2	0.2	Mar	3	2	1	1	Returning_Visitor	False	False	4
41	1	0.2	0.2	May	1	1	4	3	Returning_Visitor	False	False	4
60	1	0.2	0.2	Nov	2	2	1	1	Returning_Visitor	False	False	4
0	1	0.2	0.2	Dec	1	1	1	1	Returning_Visitor	True	False	3
3	1	0.2	0.2	Dec	1	1	4	1	Returning_Visitor	True	False	3

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent